PORTFOLIO POWER BI Adam Chnok Business Intelligence Analyst adamchnok@gmail.com & ANALYTICS Showcasing Dashboard Design, Data Modeling, and Generative AI in Analytics
Content Overview Showcasing Dashboard Design, Data Modeling, and Generative AI in Analytics Server Backup Monitoring Dashboard 01 06 02 07 Proficiency in Generative AI Security Operations Dashboard Use Cases in Analytics & Reporting Incident, Request, Change Dashboard (1) Incident, Request, Change Dashboard (2) AI - Assisted Documentation Other Dashboards 03 04 08 05
Portfolio / Project Samples (Power BI)
Server Backup Monitoring Dashboard
Server Backup Monitoring Dashboard: Business Context Situation • The stakeholders needed a real - time dashboard to track which servers restarted successfully, which ones failed and monitor backup status to ensure availability. • Their existing reporting tool was limited, required heavy manual effort, and slowed down incident detection for the monitoring team. My Role Data Sources / ETL • Designed and developed the dashboard based on client requirements. • Collaborated with stakeholders to define KPIs for server health and backup availability. • SQL database of HP server hosts. • Connected via DirectQuery for live, dynamic reporting.
clearer visuals and critical metrics for incident detection. 90% Reduction in Manual Reporting Eliminated manual reporting on the whole project 5x Improved Response Faster incident detection and resolution compared to previous tools Delivered Impact / Outcome
Security Operations Dashboard
Security Operations Dashboard: Business Context Situation • The security team was responsible for sending monthly reports to executives, but the process was entirely manual. Preparing the slides often took several days of effort. • The reports were static and lacked flexibility, executives couldn’t easily filter by specific months or look back at historical data without requesting additional files. My Role Data Sources / ETL • Designed and developed a new dashboard tailored to the team’s reporting needs, focusing on automation and interactivity. • Optimized an existing dashboard by improving its structure and correcting KPI calculations using DAX measures to ensure data accuracy. • Data was provided through monthly Excel extracts sent by the security team. • The files were cleaned and transformed in Power Query before being modeled in Power BI.
50% Automation Reduced the team’s end - of - month reporting workload, allowing them to focus on higher - value security tasks instead of manual reporting. Introduced dynamic features such as slicers for date and month selection, enabling executives to easily drill into past performance without needing separate reports. Improved overall accessibility, eliminating the inefficiencies of tracking outdated versions of the report. Impact / Outcome
Incident, Request, Change, SLA & Backlog Dashboard
Problem 1 • SLA measurements in ServiceNow were often incorrect because the developers responsible for maintaining them did not implement the necessary adjustments. • To avoid delays and repeated back - and - forth requests, we needed to create our own accurate version of SLA reporting. Problems 2 & 3 Problem 4 • Stakeholder teams were not highly communicative or organized, which meant that even small updates could take weeks to be implemented. • ServiceNow’s built - in reporting was too basic and limited, and some required measurements could not be created directly in the tool. • Stakeholders wanted a more reliable and visually clear reporting solution that allowed them to track SLAs and tickets anytime without depending on manual updates. Incident, Request, Change, SLA & Backlog Dashboard : Business Context (Problems)
Incident, Request, Change, SLA & Backlog Dashboard : Business Context (Solutions) My Role • Designed and developed an intuitive Power BI dashboard to present SLA metrics and KPIs requested by stakeholders. • Created custom DAX measures to replicate and correct SLA calculations, ensuring data was both accurate and live. • Adapted the design and color scheme to stakeholder preferences, focusing on simplicity and readability rather than flashy visuals. Data Sources/ ETL • Configured scheduled ServiceNow data extractions that were automatically delivered to Outlook. • Set up Power Automate to sync Outlook with SharePoint, ensuring each new extraction replaced the previous file seamlessly and on daily basis. • Connected Power BI to SharePoint so the report stayed updated automatically without requiring manual refreshes or SQL/API setup.
Impact / Outcome Delivered a fully automated reporting process, removing the need for manual intervention or complex SQL/API integrations. Over 10 executives used the dashboard daily, making it a trusted tool for SLA and ticket tracking. Helped executives keep weekly meetings on schedule by providing accurate, timely insights, unlike the old static reports that often caused delays.
Incident, Request, Change & SLA Tables Dashboard
Situations 1 & 2 • The IT team needed an automated reporting solution to present accurate metrics to multiple stakeholders. • All stakeholders used the same ticketing tool, which often caused data overlaps, mixed reports, and in some cases, incorrect information. Situations 3 & 4 • During monthly reviews, the IT team had to manually prepare over 8 different PowerPoint decks, each tailored to a specific stakeholder’s metrics. This was time - consuming and error - prone. • Stakeholders insisted on reports being presented in table format similar to Excel, even though Power BI is not natively optimized for Excel - style layouts. Incident, Request, Change & SLA Tables Dashboard: Business Context (Problems)
My Role • Designed and developed an intuitive Power BI dashboard that replicated SLA and KPI reports in a clean, Excel - like format. • Built a Project slicer to differentiate each stakeholder’s company data, ensuring that all visuals, logos, and metrics dynamically adjusted based on the selected project. • Enabled stakeholders to use the same report but view it in a personalized way depending on the project selection. Data Sources/ ETL • Used raw Excel extractions provided by IT teams. • Cleaned and transformed data in Power Query before building the model in Power BI. Incident, Request, Change & SLA Tables Dashboard: Business Context (Solutions)
Impact / Outcome Delivered a simple, user - friendly dashboard that looked and functioned almost exactly like stakeholders’ familiar Excel tables by mimicking the pivot tables, easing adoption. Saved the IT team hours of manual effort each month by eliminating the need to filter massive Excel extracts and build 8 separate stakeholder - specific versions. Standardized reporting timelines and all stakeholders now receive their reports on the same day each month, ensuring consistency and better meeting preparation.
Other Dashboards
Generative AI Familiarity
Proficiency in Using Generative AI • Proficient use of generative AI tools like ChatGPT and Copilot for analytics and reporting tasks. • Daily use for creating, troubleshooting, and optimizing DAX measures, SQL queries, and Power BI visuals. • Effective in prompting AI for both technical solutions (formulas, queries) and business - level explanations or summaries. • Use AI as a productivity booster to reduce manual effort and accelerate dashboard development.
• Used ChatGPT to troubleshoot complex DAX formulas and optimize SQL queries. DAX/SQL Help Use Cases in Analytics & Reporting
Use Cases in Analytics & Reporting • AI - assisted generation of measures, KPIs, and visual explanations. Power BI Reports
• AI optimized report creation, reduced errors, sped up delivery, and added final touches like formatting, highlighting metrics, and visual indicators (e.g., smiley face for SLA) Result Use Cases in Analytics & Reporting
Data QA 1 Data Validation : Checking source data for completeness, accuracy, and consistency before importing into Power BI. 2 Logic & Calculation Review : Verifying DAX measures, SQL queries, and transformations to ensure calculations are correct. 3 Visual Inspection: Ensuring charts, tables, and KPIs display accurate values and match source data. Checking that formatting, colors, and labels are consistent and readable. 4 End - to - End Testing: Simulating real scenarios with filters, slicers, and dynamic selections to confirm interactivity works as intended. Comparing dashboard results against historical reports or benchmark Use Cases in Analytics & Reporting
Generative AI as a Co - Pilot Generative AI helps me build dashboards faster, optimize reports with final touches, and deliver clearer, more accurate insights with less manual effort.
AI - Assisted Documentation Advanced Visualization Features AI - Assisted Documentation • Dashboard Summaries: AI generates clear, business - friendly explanations of KPIs and metrics for stakeholders. • Process Guides: Drafts step - by - step instructions for maintaining or refreshing dashboards. • Internal SOPs: Quickly creates standardized procedures for repetitive tasks. • Training Support: Produces onboarding materials or FAQs for team members. AI - assisted documentation can help create and improve emails, notes, checklists, step - by - step guides, and flowcharts, turning technical work into clear, actionable information for stakeholders and team members.
Thank you for your time Adam Chnok Business Intelligence Analyst adamchnok@gmail.com